USE [KAISHI_Web_MES]
GO

/****** Object:  Table [dbo].[DC_BrazingBlanking]    Script Date: 2024/11/1 10:40:13 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[DC_BrazingBlanking](
	[Id] [bigint] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[DCId] [varchar](255) NOT NULL,
	[ShelfNumber] [int] NULL,
	[ShelfPostion] [int] NULL,
	[PipeCheckResult1] [int] NULL,
	[PipeCheckResult2] [int] NULL,
	[PillarCheckResult1] [int] NULL,
	[PillarCheckResult2] [int] NULL,
	[WeldingHeadCheckResult] [int] NULL,
	[ClimbingFluidCheckResult] [int] NULL,
	[BottomSupportCode] [varchar](50) NULL,
	[BottomPlateQrCode] [varchar](50) NULL,
	[BakingEndTime] [datetime] NULL,
 CONSTRAINT [PK_DC_BrazingBlanking] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [KAISHI_Web_MES]
GO

/****** Object:  Table [dbo].[DC_BrazingLoading]    Script Date: 2024/11/1 10:40:47 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[DC_BrazingLoading](
	[Id] [bigint] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[DCId] [varchar](255) NOT NULL,
	[FixtureNumber] [varchar](50) NULL,
	[MagazinePosition] [int] NULL,
	[ShelfNumber] [varchar](50) NULL,
	[BrazingStartTime] [datetime] NULL,
	[HeatNumber] [int] NULL,
 CONSTRAINT [PK_DC_BrazingLoading] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [KAISHI_Web_MES]
GO

/****** Object:  Table [dbo].[DC_BottomPlateCoverAssembleClamping]    Script Date: 2024/11/1 10:41:08 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[DC_BottomPlateCoverAssembleClamping](
	[Id] [bigint] IDENTITY(1,1) NOT NULL,
	[DCId] [varchar](255) NOT NULL,
	[PressingForce] [float] NULL,
	[BottomPlateQrCode] [varchar](50) NULL,
	[CoverQrCode] [varchar](50) NULL,
	[WeldingWireBlueCode] [varchar](50) NULL,
	[FixtureNumber] [varchar](50) NULL,
	[AssembleTime] [datetime] NULL,
 CONSTRAINT [PK_DC_BottomPlateCoverAssembleClamping] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [KAISHI_Web_MES]
GO

/****** Object:  Table [dbo].[DC_BottomPlateRivetingAssemble]    Script Date: 2024/11/1 10:41:23 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[DC_BottomPlateRivetingAssemble](
	[Id] [bigint] IDENTITY(1,1) NOT NULL,
	[DCId] [varchar](255) NOT NULL,
	[PipeBlueCode] [varchar](50) NULL,
	[BottomPlateBlueCode] [varchar](50) NULL,
	[BottomPlateCode] [varchar](50) NULL,
	[BigSolderRingBlueCode] [varchar](50) NULL,
	[AssembleTime] [datetime] NULL,
 CONSTRAINT [PK_DC_BottomPlateRivetingAssemble] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [KAISHI_Web_MES]
GO

/****** Object:  Table [dbo].[DC_CoverRivetingAssemble]    Script Date: 2024/11/1 10:41:47 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[DC_CoverRivetingAssemble](
	[Id] [bigint] IDENTITY(1,1) NOT NULL,
	[DCId] [varchar](255) NOT NULL,
	[CoverCode] [varchar](50) NULL,
	[CoverBlueCode] [varchar](50) NULL,
	[PillarBlueCode] [varchar](50) NULL,
	[SmallSolderRingBlueCode] [varchar](50) NULL,
	[AssembleTime] [datetime] NULL,
 CONSTRAINT [PK_DC_CoverRivetingAssemble] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [KAISHI_Web_MES]
GO

/****** Object:  Table [dbo].[DC_WarpedSheetAssemble]    Script Date: 2024/11/1 10:42:12 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[DC_WarpedSheetAssemble](
	[Id] [bigint] IDENTITY(1,1) NOT NULL,
	[DCId] [varchar](255) NOT NULL,
	[OuterWarpedSheetNumber] [int] NULL,
	[InnerWarpedSheetNumber] [int] NULL,
	[OuterFlatness] [float] NULL,
	[InnerFlatness] [float] NULL,
	[BottomPlateQrCode] [varchar](50) NULL,
	[MediumBoardBlueCode] [varchar](50) NULL,
	[WarpedSheetBatchCode] [varchar](50) NULL,
	[AssembleTime] [datetime] NULL,
 CONSTRAINT [PK_DC_WarpedSheetAssemble] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


